package com.briup.pts.mapper;

import com.briup.pts.domain.bean.Disease;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 25095
 * @description
 * @data 2024/11/29-9:25
 */
@Mapper
public interface DiseaseMapper {

    @Select("select d_id, d_name, d_desc, d_type, " +
            "d_etiology, d_symptom, d_prevention " +
            "from manager_disease")

    List<Disease> queryAll();

    @Select("select count(d_id) " +
            "from manager_disease " +
            "where d_id=#{dId}")
    int countById(Integer dId);
}
